| ColumnName |
Domain |
Datatype |
NULL |
Definition |
FaNSLDS12ID |
|
int |
NO |
|
FaISIR12ID |
|
int |
YES |
|
| TransactionNumber |
|
char(2) |
YES |
|
| DatabaseResultsFlag |
|
char(1) |
YES |
|
| ACGOverpayFlag |
|
char(1) |
YES |
|
| ACGOverpayContact |
|
char(8) |
YES |
|
| PellOverpayFlag |
|
char(1) |
YES |
|
| PellOverpayContact |
|
char(8) |
YES |
|
| SEOGOverpayFlag |
|
char(1) |
YES |
|
| SEOGOverpayContact |
|
char(8) |
YES |
|
| PerkinsOverpayFlag |
|
char(1) |
YES |
|
| PerkinsOverpayContact |
|
char(8) |
YES |
|
| SMARTOverpayFlag |
|
char(1) |
YES |
|
| SMARTOverpayContact |
|
char(8) |
YES |
|
| TEACHOverpayFlag |
|
char(1) |
YES |
|
| TEACHOverpayContact |
|
char(8) |
YES |
|
| IRQAFGSerGrantOverpayFlag |
|
char(1) |
YES |
|
| IRQAFGSerGrantOverpayContact |
|
char(8) |
YES |
|
| DefaultedLoanFlag |
|
char(1) |
YES |
|
| DischargedLoanFlag |
|
char(1) |
YES |
|
| FraudLoanFlag |
|
char(1) |
YES |
|
| LoanSatisfactoryRepaymentFlag |
|
char(1) |
YES |
|
| ActiveBankruptcyFlag |
|
char(1) |
YES |
|
| TEACHLoanConversionFlag |
|
char(1) |
YES |
|
| AggrSubsidizedBal |
|
decimal(6, 0) |
YES |
|
| AggrUnSubBal |
|
decimal(6, 0) |
YES |
|
| AggrCombinedBal |
|
decimal(6, 0) |
YES |
|
| AggrConsolidatedBal |
|
decimal(6, 0) |
YES |
|
| AggrTEACHBal |
|
decimal(6, 0) |
YES |
|
| AggrSubsidizedDisb |
|
decimal(6, 0) |
YES |
|
| AggrUnSubsidizedDisb |
|
decimal(6, 0) |
YES |
|
| AggrCombinedDisb |
|
decimal(6, 0) |
YES |
|
| AggrSubsidizedTotal |
|
decimal(6, 0) |
YES |
|
| AggrUnsubTotal |
|
decimal(6, 0) |
YES |
|
| AggrCombinedTotal |
|
decimal(6, 0) |
YES |
|
| AggrConsolidatedTotal |
|
decimal(6, 0) |
YES |
|
| AggrTEACHTotal |
|
decimal(6, 0) |
YES |
|
| PerkinsPrintBalance |
|
decimal(6, 0) |
YES |
|
| PerkinsCurrYrLoanAmount |
|
decimal(6, 0) |
YES |
|
| AggrTEACHUnderGradDisbAmount |
|
decimal(6, 0) |
YES |
|
| AggrTEACHGradDisbAmount |
|
decimal(6, 0) |
YES |
|
| DefaultChangeFlag |
|
char(1) |
YES |
|
| FraudChangeFlag |
|
char(1) |
YES |
|
| DischargedChangeFlag |
|
char(1) |
YES |
|
| SatRepayChangeFlag |
|
char(1) |
YES |
|
| ActiveBankruptChangeFlag |
|
char(1) |
YES |
|
| TEACHLoanChangeFlag |
|
char(1) |
YES |
|
| OverpaymentsChangeFlag |
|
char(1) |
YES |
|
| AggrLoanChangeFlag |
|
char(1) |
YES |
|
| PerkinsLoanChangeFlag |
|
char(1) |
YES |
|
| PellPaymentChangeFlag |
|
char(1) |
YES |
|
| ACGPaymentChangeFlag |
|
char(1) |
YES |
|
| SMARTPaymentChangeFlag |
|
char(1) |
YES |
|
| TEACHPaymentChangeFlag |
|
char(1) |
YES |
|
| AdditionalPellFlag |
|
char(1) |
YES |
|
| AdditionalLoansFlag |
|
char(1) |
YES |
|
| AdditionalACGFlag |
|
char(1) |
YES |
|
| AdditionalSMARTFlag |
|
char(1) |
YES |
|
| AdditionalTEACHFlag |
|
char(1) |
YES |
|
| DLPromNote |
|
char(1) |
YES |
|
| DLPLUSPromNote |
|
char(1) |
YES |
|
| DLGradPLUSPromNote |
|
char(1) |
YES |
|
| SubsidizedLoanLimitFlag |
|
char(1) |
YES |
|
| CombinedLoanLimitFlag |
|
char(1) |
YES |
|
| GradSubsidizedLoanLimitFlag |
|
char(1) |
YES |
|
| GradCombinedLoanLimitFlag |
|
char(1) |
YES |
|
UserID |
|
int |
NO |
|
| DateAdded |
|
datetime |
NO |
|
| DateLstMod |
|
datetime |
NO |
|
| ts |
|
timestamp |
NO |
|